	USE INB201
GO
INSERT INTO [dbo].[users]
           ([user_id]
           ,[user_name]
           ,[user_type]
           ,[password]
           ,[group_name]
           ,[phone_number]
           ,[email])
VALUES ('n7181000', 'Alice Right', 'student', 'password','Team Awesome','0412449867','AliceRight@qut.edu.au')
, ('n7181001', 'Bob Nice', 'student', 'password','Team Awesome','0415566421','BobNice@qut.edu.au')
, ('n7181005', 'Gary Grey', 'student', 'password','Team Awesome','0421354465','GaryGrey@qut.edu.au')
, ('n7181006', 'Minnie Mouse', 'student', 'password','Team Awesome','0484745132','MinnieMouse@qut.edu.au')
,('n7181002', 'Charlie Browm', 'student', 'password','Team Ok','0448481152','CharlieBrowm@qut.edu.au')
, ('n7181003', 'Dan Luck', 'student', 'password','Team Bad','0413352357','DanLuck@qut.edu.au')
,('n7181004', 'Ben Glover', 'student', 'password','Team Bad','0418465191','BenGlover@qut.edu.au')
, ('scrsa', 'Sarah Screen', 'tutor', 'password',NULL,'0461543219','SarahScreen@qut.edu.au')
, ('groma', 'Martin Ground', 'tutor', 'password',NULL,'0421648579','MartinGround@qut.edu.au')
, ('tutor', 'Tutor Demo', 'tutor', 'password',NULL,'0462449845','TutorDemo@qut.edu.au')

INSERT INTO [dbo].[tutorresults]
           ([week]
           ,[user_name]
           ,[user_id]
           ,[group_name]
           ,[mark]
           ,[comment])
VALUES ('1', 'Alice Right', 'n7181000', 'Team Awesome', '7', 'Alice did well this week')
, ('1', 'Bob Nice', 'n7181001', 'Team Awesome', '9', 'Bob is a hard worker')
, ('1', 'Charlie Browm', 'n7181002', 'Team Ok', '5', 'Charlie is an average worker')
, ('1', 'Dan Luck', 'n7181003', 'Team Bad', '1', 'Dan sucks')
, ('1', 'Ben Dover', 'n7181004', 'Team Bad', '1', 'Ben has terrible work ethic')
, ('1', 'Gary Grey', 'n7181005', 'Team Awesome','8','Gary works well')
, ('1', 'Minnie Mouse', 'n7181006','Team Awesome','9','Minnie is awesome')
, ('2', 'Alice Right', 'n7181000', 'Team Awesome', '9', 'Alice improved tremendously')
, ('2', 'Bob Nice', 'n7181001', 'Team Awesome', '10', 'Bob is a exceptional')
, ('2', 'Charlie Browm', 'n7181002','Team Ok', '4', 'Charlie is just ok')
, ('2', 'Dan Luck', 'n7181003', 'Team Bad', '2', 'Dan is still bad')
, ('2', 'Ben Dover', 'n7181004', 'Team Bad', '0', 'Ben  does no work')
, ('2', 'Gary Grey', 'n7181005', 'Team Awesome','7','Gary works epically')
, ('2', 'Minnie Mouse', 'n7181006','Team Awesome','10','Minnie is outstanding')
, ('3', 'Alice Right', 'n7181000', 'Team Awesome', '7', 'Alice did well this week')
, ('4', 'Alice Right', 'n7181000', 'Team Awesome', '8', 'Alice did well this week')
, ('5', 'Alice Right', 'n7181000', 'Team Awesome', '7', 'Alice did well this week')
, ('6', 'Alice Right', 'n7181000', 'Team Awesome', '9', 'Alice did well this week')
, ('7', 'Alice Right', 'n7181000', 'Team Awesome', '10', 'Alice did well this week')
, ('8', 'Alice Right', 'n7181000', 'Team Awesome', '7', 'Alice did well this week')
, ('9', 'Alice Right', 'n7181000', 'Team Awesome', '8', 'Alice did well this week')
, ('10', 'Alice Right', 'n7181000', 'Team Awesome', '9', 'Alice did well this week')
, ('11', 'Alice Right', 'n7181000', 'Team Awesome', '9', 'Alice did well this week')
, ('12', 'Alice Right', 'n7181000', 'Team Awesome', '8', 'Alice did well this week')
, ('13', 'Alice Right', 'n7181000', 'Team Awesome', '10', 'Alice did well this week')

INSERT INTO [dbo].[studentreviews]
           ([week]
           ,[user_id]
           ,[reviewee]
           ,[mark]
           ,[comment])
VALUES ('1', 'n7181001', 'n7181000', '10', 'Alice is da bomb')
	, ('1', 'n7181000', 'n7181001', '9', 'Bob is a great team member')
	, ('1', 'n7181003', 'n7181004', '1', 'Ben is bad')
	, ('1', 'n7181004', 'n7181003', '8', 'Dan bad')
	, ('1', 'n7181000', 'n7181005', '8', 'Gary awesome')
	, ('1', 'n7181000', 'n7181006', '8', 'Dan smells')
	, ('1', 'n7181001', 'n7181005', '10', 'Gary the bomb')
	, ('1', 'n7181001', 'n7181006', '8', 'Minnie superb')
	, ('1', 'n7181005', 'n7181000', '9', 'Alice great')
	, ('1', 'n7181005', 'n7181001', '7', 'Bob great')
	, ('1', 'n7181005', 'n7181006', '8', 'Minnie great')
	, ('1', 'n7181006', 'n7181000', '9', 'Alice great')
	, ('1', 'n7181006', 'n7181001', '9', 'Bob great')
	, ('1', 'n7181006', 'n7181005', '8', 'Gary great')
	, ('2', 'n7181001', 'n7181000', '9', 'Alice improved tremendously')
	, ('2', 'n7181000', 'n7181001', '10', 'Bob is a exceptional')
	, ('2', 'n7181003', 'n7181004', '4', 'Ben is lazy')
	, ('2', 'n7181004', 'n7181003', '2', 'Dan is still bad')
	, ('2', 'n7181000', 'n7181005', '9', 'Gary awesome')
	, ('2', 'n7181000', 'n7181006', '10', 'Dan smells')
	, ('2', 'n7181001', 'n7181005', '9', 'Gary the bomb')
	, ('2', 'n7181001', 'n7181006', '7', 'Minnie superb')
	, ('2', 'n7181005', 'n7181000', '9', 'Alice great')
	, ('2', 'n7181005', 'n7181001', '8', 'Bob great')
	, ('2', 'n7181005', 'n7181006', '9', 'Minnie great')
	, ('2', 'n7181006', 'n7181000', '10', 'Alice great')
	, ('2', 'n7181006', 'n7181001', '10', 'Bob great')
	, ('2', 'n7181006', 'n7181005', '9', 'Gary great')
	, ('3', 'n7181001', 'n7181000', '7', 'Alice is da bomb')
	, ('4', 'n7181001', 'n7181000', '8', 'Alice is da bomb')
	, ('5', 'n7181001', 'n7181000', '9', 'Alice is da bomb')
	, ('6', 'n7181001', 'n7181000', '10', 'Alice is da bomb')
	, ('7', 'n7181001', 'n7181000', '9', 'Alice is da bomb')
	, ('8', 'n7181001', 'n7181000', '8', 'Alice is da bomb')
	, ('9', 'n7181001', 'n7181000', '7', 'Alice is da bomb')
	, ('10', 'n7181001', 'n7181000', '6', 'Alice is da bomb')
	, ('11', 'n7181001', 'n7181000', '9', 'Alice is da bomb')
	, ('12', 'n7181001', 'n7181000', '10', 'Alice is da bomb')
	, ('13', 'n7181001', 'n7181000', '8', 'Alice is da bomb')

